package org.ilead.iserve.dao.impl;

import java.sql.Timestamp;
import java.util.List;
import org.hibernate.LockMode;
import org.ilead.iserve.dao.IResourceDAO;
import org.ilead.iserve.model.Resource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

/**
 * A data access object (DAO) providing persistence and search support for
 * Resource entities. Transaction control of the save(), update() and delete()
 * operations can directly support Spring container-managed transactions or they
 * can be augmented to handle user-managed Spring transactions. Each of these
 * methods provides additional information for how to configure it for the
 * desired type of transaction control.
 * 
 * @see org.ilead.iserve.model.Resource
 * @author MyEclipse Persistence Tools
 */

public class ResourceDAO extends HibernateDaoSupport implements IResourceDAO {
	private static final Logger log = LoggerFactory
			.getLogger(ResourceDAO.class);
	protected void initDao() {
		// do nothing
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#save(org.ilead.iserve.model.Resource)
	 */
	@Override
	public void save(Resource transientInstance) {
		log.debug("saving Resource instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#delete(org.ilead.iserve.model.Resource)
	 */
	@Override
	public void delete(Resource persistentInstance) {
		log.debug("deleting Resource instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findById(java.lang.Integer)
	 */
	@Override
	public Resource findById(java.lang.Integer id) {
		log.debug("getting Resource instance with id: " + id);
		try {
			Resource instance = (Resource) getHibernateTemplate().get(
					"org.ilead.iserve.model.Resource", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByExample(org.ilead.iserve.model.Resource)
	 */
	@Override
	public List findByExample(Resource instance) {
		log.debug("finding Resource instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value, String orderBy) {
		log.debug("finding Resource instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Resource as model where model."
					+ propertyName + "= ?" + orderBy;
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}
	
	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByProperty(java.lang.String, java.lang.Object)
	 */
	@Override
	public List findByProperty(String propertyName, Object value) {
		return findByProperty(propertyName, value, "");
	}
	
	

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByName(java.lang.Object)
	 */
	@Override
	public List findByName(Object name) {
		return findByProperty(NAME, name);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByDescription(java.lang.Object)
	 */
	@Override
	public List findByDescription(Object description) {
		return findByProperty(DESCRIPTION, description);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByType(java.lang.Object)
	 */
	@Override
	public List findByType(Object type) {
		return findByProperty(TYPE, type, "order by model.gmtModify desc");
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByUrl(java.lang.Object)
	 */
	@Override
	public List findByUrl(Object url) {
		return findByProperty(URL, url);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByImage(java.lang.Object)
	 */
	@Override
	public List findByImage(Object image) {
		return findByProperty(IMAGE, image);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByOperator(java.lang.Object)
	 */
	@Override
	public List findByOperator(Object operator) {
		return findByProperty(OPERATOR, operator);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findByStatus(java.lang.Object)
	 */
	@Override
	public List findByStatus(Object status) {
		return findByProperty(STATUS, status);
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#findAll()
	 */
	@Override
	public List findAll() {
		log.debug("finding all Resource instances");
		try {
			String queryString = "from Resource";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#merge(org.ilead.iserve.model.Resource)
	 */
	@Override
	public Resource merge(Resource detachedInstance) {
		log.debug("merging Resource instance");
		try {
			Resource result = (Resource) getHibernateTemplate().merge(
					detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#attachDirty(org.ilead.iserve.model.Resource)
	 */
	@Override
	public void attachDirty(Resource instance) {
		log.debug("attaching dirty Resource instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	/* (non-Javadoc)
	 * @see org.ilead.iserve.dao.impl.IResourceDAO#attachClean(org.ilead.iserve.model.Resource)
	 */
	@Override
	public void attachClean(Resource instance) {
		log.debug("attaching clean Resource instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static IResourceDAO getFromApplicationContext(ApplicationContext ctx) {
		return (IResourceDAO) ctx.getBean("ResourceDAO");
	}
}